2013-03-21 - 5910.200 - Rel Notes - Contracts - Release 005 #BIReleases2013
Release Notes:
5910.200 - Contracts - OSA905
Admin Info
Purpose
|
Including Contract Information in OSA900 report
|
Release No
|
005
|
Submitted
|
03-21-2013
|
Submitted by
|
Mallareddy D
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Mallareddy D
|
Object(s) Tested By
|
Praveen Guntuka
|
Report Name
OSA905 - Open Orders by Sales Org, SBU, Sales Rep, Customer, Season, Collection and Material
BEx Query
ZMP_OPASA_Q030
NEC Crystal Reports Standards Check
1. OSA905 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. OSA905 NEC CR checklist has been sent to NEC and also attached here for reference.
OSA905 NEC CR Standard Check List.xlsx
Dynamic Group 1:
Test Conducted
Dynamic Grouping Parameter(1) and Group Name: SBU > Sales Rep > Customer > Season > Collection > Material
Summary Level Check
Test Conducted
Group: Sales Orgs - 5th & Ocean Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,440,683
|
1,440,683
|
Pass
|
2
|
Sales Org Currency
|
13,492,910
|
13,492,910.07
|
Pass
|
3
|
Corporate Currency
|
13,492,910
|
13,492,910.07
|
Pass
|
Group: Sales Orgs - EMEA Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,792,560
|
1,792,560
|
Pass
|
2
|
Sales Org Currency
|
15,654,081
|
15,654,084.20
|
Fail
|
3
|
Corporate Currency
|
23,839,640
|
23,839,597.43
|
Fail
|
Note: For EMEA Sales, Sales Org, Sales Org Currency and Corporate Currency values are not matching with BEx Query values. The difference is $3 and $43 respectively.
Second Level Check
Test Conducted
Group: APAC Sales > Accessories
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,209
|
1,209
|
Pass
|
2
|
Sales Org Currency
|
136,577
|
136,576.63
|
Pass
|
3
|
Corporate Currency
|
17,611
|
17,610.52
|
Pass
|
Third Level Check
Test Conducted
Group: Australia Sales > HeadWear > Brian O'Meara
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
10,096
|
10,096
|
Pass
|
2
|
Sales Org Currency
|
211,177
|
211,177.17
|
Pass
|
3
|
Corporate Currency
|
216,393
|
216,393.25
|
Pass
|
Group : EMEA Sales > Headwear > Charles Colleville
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
20,179
|
20,179
|
Pass
|
2
|
Sales Org Currency
|
221,247
|
221,248.63
|
Fail
|
3
|
Corporate Currency
|
336,930
|
336,927.37
|
Fail
|
Note: For EMEA Sales, Sales Org, Sales Org Currency and Corporate Currency values are not matching with BEx Query values. The difference is $2 and $3 respectively because of rounding issue.
Fourth Level Check
Test Conducted
Group: EMEA Sales > Accessories > Aldo Goldoni > 1011195 AMANITO SMART SHOP
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
12
|
12
|
Pass
|
2
|
Sales Org Currency
|
79
|
79.24
|
Pass
|
3
|
Corporate Currency
|
121
|
120.68
|
Pass
|
Fifth Level Check
Test Conducted
Group: Canada Sales > Mens Apparel > Drew Van Iderstine > 1006966 GAME ON SPORTS > CFL SPR13 MAY 13 13
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
264
|
264
|
Pass
|
2
|
Sales Org Currency
|
5,330
|
5,330.16
|
Pass
|
3
|
Corporate Currency
|
5,235
|
5,234.75
|
Pass
|
Sixth Level Check
Test Conducted
Group: German Sales > Headwear > Jan Henning > 1004350 GALERIA KAUFHOF GMBH > Residual > SEAS BASIC
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
35
|
35
|
Pass
|
2
|
Sales Org Currency
|
280
|
280.00
|
Pass
|
3
|
Corporate Currency
|
370
|
370.50
|
Pass
|
Seventh Level Check
Test Conducted
Group: United States Sales > Fan Gear > Andrew Kouwe > 1009141 BIG JAS > FAN FALL 4 - 8 5 13 > Crayon Box > 10804889 CRAYON BOX CHIBEA TEAM
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
6
|
6
|
Pass
|
2
|
Sales Org Currency
|
82
|
82.32
|
Pass
|
3
|
Corporate Currency
|
82
|
82.32
|
Pass
|
Dynamic Group 2:
Test Conducted
Dynamic Grouping Parameter(2) and Group Name: Sales Rep > Customer > Season > Collection > Material
Summary Level Check
Test Conducted
Group: Sales Orgs - APAC Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
73,956
|
73,956
|
Pass
|
2
|
Sales Org Currency
|
7,971,473
|
7,971,472.89
|
Pass
|
3
|
Corporate Currency
|
1,027,861
|
1,027,860.96
|
Pass
|
Group: Sales Orgs - EMEA Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,792,560
|
1,792,560
|
Pass
|
2
|
Sales Org Currency
|
15,654,081
|
15,654,084.20
|
Fail
|
3
|
Corporate Currency
|
23,839,640
|
23,839,597.43
|
Fail
|
Note: For EMEA Sales, Sales Org, Sales Org Currency and Corporate Currency values are not matching with BEx Query values. The difference is $3 and $43 respectively.
Second Level Check
Test Conducted
Group: Australia Sales > Arthur Kerr
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
18,644
|
18,644
|
Pass
|
2
|
Sales Org Currency
|
353,682
|
353,681.57
|
Pass
|
3
|
Corporate Currency
|
362,418
|
362,417.50
|
Pass
|
Third Level Check
Test Conducted
Group: German Sales > Jan Henning > 1004350 GALERIA KAUFHOF GMBH
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,435
|
1,435
|
Pass
|
2
|
Sales Org Currency
|
17,113
|
17,113.30
|
Pass
|
3
|
Corporate Currency
|
22,645
|
22,644.32
|
Pass
|
Fourth Level Check
Test Conducted
Group: Mexico Sales > Alex Noguera > 1013489 CLUB DE BASE BALL TIGRES SA DE CV > Custom
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
401
|
401
|
Pass
|
2
|
Sales Org Currency
|
62,867
|
62,867.33
|
Pass
|
3
|
Corporate Currency
|
4,929
|
4,928.80
|
Pass
|
Fifth Level Check
Test Conducted
Group: United State Sales > Acker/Tracy > 1004940 KOHLS ACCOUNTS PAYBLE > WomAppFall-Jul 15 13 > 4859W
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
288
|
288
|
Pass
|
2
|
Sales Org Currency
|
4,277
|
4,276.80
|
Pass
|
3
|
Corporate Currency
|
4,277
|
4,276.80
|
Pass
|
Sixth Level Check
Test Conducted
Group: Latin America Sales > Alfredo Alvarez > 1007635 DANIEL GARCIA > Custom > CUS 9FIFTY SNAP > 70173891 950 CHIWHI CY YELL WH VISOR
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
144
|
144
|
Pass
|
2
|
Sales Org Currency
|
1,613
|
1,612.80
|
Pass
|
3
|
Corporate Currency
|
1,613
|
1,612.80
|
Pass
|
Reference Document (Specification)
2013-03-15 - 5910.200 - Spec - Contract Reports